package idv.loveloser.dao;

import java.util.List;
import org.hibernate.LockMode;
import org.hibernate.Query;
import org.hibernate.criterion.Example;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

/**
 * A data access object (DAO) providing persistence and search support for
 * MdlQuestionSessions entities. Transaction control of the save(), update() and
 * delete() operations can directly support Spring container-managed
 * transactions or they can be augmented to handle user-managed Spring
 * transactions. Each of these methods provides additional information for how
 * to configure it for the desired type of transaction control.
 * 
 * @see idv.loveloser.dao.MdlQuestionSessions
 * @author MyEclipse Persistence Tools
 */

public class MdlQuestionSessionsDAO extends BaseHibernateDAO {
	private static final Logger log = LoggerFactory
			.getLogger(MdlQuestionSessionsDAO.class);
	// property constants
	public static final String ATTEMPTID = "attemptid";
	public static final String QUESTIONID = "questionid";
	public static final String NEWEST = "newest";
	public static final String NEWGRADED = "newgraded";
	public static final String SUMPENALTY = "sumpenalty";
	public static final String MANUALCOMMENT = "manualcomment";
	public static final String MANUALCOMMENTFORMAT = "manualcommentformat";
	public static final String FLAGGED = "flagged";

	public void save(MdlQuestionSessions transientInstance) {
		log.debug("saving MdlQuestionSessions instance");
		try {
			getSession().save(transientInstance);
			log.debug("save successful");
		} catch (RuntimeException re) {
			log.error("save failed", re);
			throw re;
		}
	}

	public void delete(MdlQuestionSessions persistentInstance) {
		log.debug("deleting MdlQuestionSessions instance");
		try {
			getSession().delete(persistentInstance);
			log.debug("delete successful");
		} catch (RuntimeException re) {
			log.error("delete failed", re);
			throw re;
		}
	}

	public MdlQuestionSessions findById(java.lang.Long id) {
		log.debug("getting MdlQuestionSessions instance with id: " + id);
		try {
			MdlQuestionSessions instance = (MdlQuestionSessions) getSession()
					.get("idv.loveloser.dao.MdlQuestionSessions", id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}

	public List findByExample(MdlQuestionSessions instance) {
		log.debug("finding MdlQuestionSessions instance by example");
		try {
			List results = getSession()
					.createCriteria("idv.loveloser.dao.MdlQuestionSessions")
					.add(Example.create(instance)).list();
			log.debug("find by example successful, result size: "
					+ results.size());
			return results;
		} catch (RuntimeException re) {
			log.error("find by example failed", re);
			throw re;
		}
	}

	public List findByProperty(String propertyName, Object value) {
		log.debug("finding MdlQuestionSessions instance with property: "
				+ propertyName + ", value: " + value);
		try {
			String queryString = "from MdlQuestionSessions as model where model."
					+ propertyName + "= ?";
			Query queryObject = getSession().createQuery(queryString);
			queryObject.setParameter(0, value);
			return queryObject.list();
		} catch (RuntimeException re) {
			log.error("find by property name failed", re);
			throw re;
		}
	}

	public List findByAttemptid(Object attemptid) {
		return findByProperty(ATTEMPTID, attemptid);
	}

	public List findByQuestionid(Object questionid) {
		return findByProperty(QUESTIONID, questionid);
	}

	public List findByNewest(Object newest) {
		return findByProperty(NEWEST, newest);
	}

	public List findByNewgraded(Object newgraded) {
		return findByProperty(NEWGRADED, newgraded);
	}

	public List findBySumpenalty(Object sumpenalty) {
		return findByProperty(SUMPENALTY, sumpenalty);
	}

	public List findByManualcomment(Object manualcomment) {
		return findByProperty(MANUALCOMMENT, manualcomment);
	}

	public List findByManualcommentformat(Object manualcommentformat) {
		return findByProperty(MANUALCOMMENTFORMAT, manualcommentformat);
	}

	public List findByFlagged(Object flagged) {
		return findByProperty(FLAGGED, flagged);
	}

	public List findAll() {
		log.debug("finding all MdlQuestionSessions instances");
		try {
			String queryString = "from MdlQuestionSessions";
			Query queryObject = getSession().createQuery(queryString);
			return queryObject.list();
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}

	public MdlQuestionSessions merge(MdlQuestionSessions detachedInstance) {
		log.debug("merging MdlQuestionSessions instance");
		try {
			MdlQuestionSessions result = (MdlQuestionSessions) getSession()
					.merge(detachedInstance);
			log.debug("merge successful");
			return result;
		} catch (RuntimeException re) {
			log.error("merge failed", re);
			throw re;
		}
	}

	public void attachDirty(MdlQuestionSessions instance) {
		log.debug("attaching dirty MdlQuestionSessions instance");
		try {
			getSession().saveOrUpdate(instance);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public void attachClean(MdlQuestionSessions instance) {
		log.debug("attaching clean MdlQuestionSessions instance");
		try {
			getSession().lock(instance, LockMode.NONE);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}
}